Viewing 15 posts - 901 through 915 (of 1,179 total)
I guess, Backup / Restore is the best bate here and you can also restore latest t-log to get data close to current.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 14, 2009 at 11:49 pm
To install sql server clustering you need OS clustering first and I doubt VISTA provide the same. you need a server.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 14, 2009 at 11:43 pm
.bak is like a snapshot of your current database whatever is there in your current database it will restore the same way.
Refer following link for more detail on sp_spaceused:
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/c6253b48-29f5-4371-bfcd-3ef404060621.htm
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 14, 2009 at 11:21 pm
Duplicate post. Avoid dupliation please.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 14, 2009 at 7:05 am
Another scenario to shrink the log is when you don't have sufficient disk space and your log is abnormally huge. But it's not ideal to shrink log often.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 10, 2009 at 12:41 am
If I am not wrong; upgradation can't be done from X86 to X64.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 9, 2009 at 6:17 am
You can also execute following command to check Database version
select serverproperty ('ProductVersion')
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 9, 2009 at 6:12 am
You can also execute following command to check Database version
select serverproperty ('ProductVersion')
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 9, 2009 at 6:11 am
You can also execute following command to check Database version
select serverproperty ('ProductVersion')
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 9, 2009 at 6:11 am
Chek out if table partion can hlep in your scenario.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 9, 2009 at 12:45 am
Chek out if table partion can hlep in your scenario.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 9, 2009 at 12:45 am
You did get it. I want you to register the server first. And than connect.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:43 pm
Register the other network machine to the primary server; if successful. Do Logshipping through wizard.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:35 pm
Check you do have sufficient privilages to connect to the said server.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:30 pm
Surely you can put db in simple recovery mode and it will help but before changing recovery model make sure this database is not used into production.
If you will...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
July 8, 2009 at 11:26 pm
Viewing 15 posts - 901 through 915 (of 1,179 total)