|
|
Browse by Tags
All Tags » restore ( RSS)
-
|
The error on the subject line is not a good sign when you have the mammoth task of moving SQL Server system databases, I would agree that the task of system databases migration is not a day-to-day task and you must have practised the required steps. For...
|
-
|
I think some users may not like it when certain features are mentioned as they are available in Enterprise Edition aka 'Enterprise Only'! It is not so easy to provide the great features with a minimal or free cost for any product, hence the licensing...
|
-
|
In continuation to the SQL Server 2005 - adhoc script to perform backup, restore and integrity checks/optimization jobs without Database Maintenance plans? blog and scripts by Ola Hallengren, I presume they are very useful for the DBAs who are looking...
|
-
|
Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...
|
-
|
To cut the long story short, during a recent implementation of Cumulative Update 6 and 7 on a particular 'application domain' server we have had major application issues due to a mix up of application code & these SQL cumulative update fixes...
|
-
|
Since the evolution of SQL Server 2000 version the backup and restore methods have been enhanced for better performance to provide a better option for the DBA, as usual the backup and restore operations are an integral part of the Analysis Services infrastructure...
|
-
|
Backup and restore practices are at the core of today's best business continuity plans. While backup and restore provides many benefits, it simultaneously presents a variety of challenges with lost data, the time it takes to restore data, and the...
|
-
|
The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...
|
-
|
I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...
|
-
|
Interesting question: how can we know the difference between a native backup and backup taken by third party tool? Say you have started newly in a enterprise wide platform and your task is to find out what methods of BACKUP and RESTORE are followed to...
|
-
|
If you have been using the database diagrams from SQL Server 2000 onwards and when it is upgraded to SQL 2005 you might get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects...
|
-
|
Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then...
|
|
|