|
|
-
|
|
Recently, one of our DBA restored a database on live server, but with old backup accidently. Later on, we have found that it was hard to detect which backup was actually restored. To check, which backups we have created for database we have a perfect scri...
|
|
-
|
|
Normal 0 MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding...
|
|
-
|
|
This morning in log report of one of our production server I found an unusual error.DeviceIoControl failed, error 21 DeviceIOControl is a function which sends code to your disk drivers to perform read or writes functions and error 21 clearly indicates ...
|
|
-
|
|
Yes you can restore a backup file which is taken from SQL Server Enterprise Edition to Standard Edition BUT if source database is not using Enterprise Edition Specific Features. Like partition functions in our case. This happened to one of my junior, wh...
|
|
-
|
|
Problem occurs when we try to restore a database from backup set, but using MOVE option and when you provide wrong logical name of file in MOVE section of RESTORE script. To avoid this problem, first, one must verify original logical names of files by us...
|
|
-
|
|
Up to SQL Server 2008 R2 (10.5), we were unable to change default path (easily) for “Backup files”, though it was possible after making some changes in registry at path. “HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\Microsoft SQL Server\MSSQL.1\ MSSQLServer\Back...
|
|
-
|
|
Backup process in SQL Server Denali is quite same to previous versions. But there are few changes in restore dialog box.Restore dialog box is now divided into three tabs instead of two. General tab is almost same to existing versions but options ...
|
|