Viewing 15 posts - 1,006 through 1,020 (of 1,179 total)
Refer the following link:
http://support.microsoft.com/kb/224071/
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 5, 2009 at 5:29 am
Hello,
If your environment is Production & 24x 7; You can think about Indexdefrag instead of reindexing. Also if you are using the SQL Server 2005 Ent you can do the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 4, 2009 at 11:54 pm
In Services.msc if SQL Server agent is stuck and shows the status restarting since long...
You need to stop it from command prompt:
net stop "SQL Server Agent(MSSQLSERVER)"
Once stoped; start it:
net start...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 2, 2009 at 5:15 am
You can use robocopy in .bat file
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 2, 2009 at 5:08 am
Option is 1 is very prectical and unless you do have VLDB as mention by Jonathan it's perfect solution.
If your DB is very critical and would like to minimise the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 2, 2009 at 5:04 am
I mean you can restore database in Development SQL Server 2000 and detach it from there and attach to new server SQL 2005.
I know this route is longer but...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 11, 2008 at 10:56 pm
If restore is not working do detach and attach database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 11, 2008 at 10:53 pm
If possible, frist of all run DBCC CHECKDB to make sure there are no error into the database.
Take Backup as you have mention.
Perform the Shrink in small chunk i.e. 500...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 11, 2008 at 3:04 am
As mention by GilaMonster exe following T-sql
select * from sys.master_files
search the specific file.
Execute the above query on all the available instances.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 11, 2008 at 12:43 am
You need to check whethere same file is used by other instance or databases.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 11, 2008 at 12:32 am
Execute following command e.g. pubs database
sp_helpdb pubs
It will show all the details of the file used by the specific database.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 10, 2008 at 11:49 pm
From your description I understand that your logshipping is working fine. And you can't access the database.
Now there are two scenario one is you can keep your secondary database in...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 10, 2008 at 6:20 am
Thank you, happycat59 for Clarification 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 10, 2008 at 6:06 am
Ajay,
You can scroll all the way down in the 'Post Reply' window; below post Options > Messgae Icons there is "Attachments" you can click Edit Attachments.
Cheers!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 10, 2008 at 6:02 am
Hello Paresh,
Nice try to understand the SQL Backup.
Just think one step ahead of and try to understand the internal mechanism...
When full backup is running it is taking the snapshot of...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
December 8, 2008 at 10:18 pm
Viewing 15 posts - 1,006 through 1,020 (of 1,179 total)