This is a private lounge for those that have subscribed to Windows Forum. To subscribe to Windows Forum and give your support, please click the subscription link in the top navigation bar or visit your control panel.
It was just my luck to find one card under a removable panel on the underside - but the second card was under the key board. I had to remove the keyboard and all sorts of gubbins to get at it. Everything is so crammed together - I don't think I would try to build one from scratch even if DIY Components were available. I imagine the cost would be prohibitive anyway.
The USB drive is an essential part of daily life for carrying data anywhere. The USB drive/SD card is so small that it can carry thousands of photos, music videos in your single small chip. what will you do if your USB flash drive /SD card gets corrupted? continue reading
How to Take backup of All of the Databases available on instance ? Sometimes Its required to take all of the Databases to be backed up periodically for more reliable backup process. If You require to get backup of any critical server's Database then You shouldn't do manually always, It will be better to automate the Process.
SQL Query to take backup for All the Databases:-
DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file name
-- specify database backup directory SET @path = 'D:\BKP\'
-- specify filename format SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112)
DECLARE db_cursor CURSOR READ_ONLY FOR SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master','model','msdb','tempdb') -- exclude these databases
OPEN db_cursor FETCH NEXT FROM db_cursor INTO @name
WHILE @@FETCH_STATUS = 0 BEGIN SET @fileName = @path + @name + '_' + @fileDate + '.BAK' BACKUP DATABASE @name TO DISK = @fileName
FETCH NEXT FROM db_cursor INTO @name END
CLOSE db_cursor DEALLOCATE db_cursor
copy the above query and save it with file name i.e- sqlbackupquery. The above query will give the Database backed up file (.bak) on the location You will set.
You can run it over SQL server Management Studio (SSMS) or on sqlcmd.
Query will give you the database backup in the described format below. DBName_YYYMMDD.BAK
You can run it from SQL CMD, with the required parameters. for Example see below.