Viewing 15 posts - 586 through 600 (of 707 total)
[quote-0I have scheduled a daily backup on some of the instances that use SQL Express.[/quote-0]
Can we schedule a backup in SQL Express..?
Just asking..I had worked in express for a small...
June 1, 2009 at 8:27 am
If am not wrong, YES. You can go with Log Shipping.
It should work fine even if both DBs are in same server.
but second database will be in either NoRecovery or...
May 28, 2009 at 4:35 am
I don't follow...Why is it required to install at same time..?
What for ..?
May 28, 2009 at 4:24 am
What kind of skills or primary skills a dba(oracle,sql,sybase,any dba) must have?
Good understanding of RDBMS.
Good understanding of the Architecture (oracle, SQL Server..)
Should ble able to design databases in a proper...
May 28, 2009 at 4:17 am
Did you check if there were dead locks? Or was it just blocking?
Can we find it out from Activity Monitor itself.?
May 28, 2009 at 3:10 am
Thanks, I will check and revert back.
May 28, 2009 at 3:08 am
Thanks for quick reply.
Sorry, I forgot to mention my SQL Server version.
It's SQL Server 2005+SP2.
The link which you have given is for SQL Server 2008.
Thanks.
May 27, 2009 at 2:19 am
sivark1 (5/26/2009)
when ever i tried to access remote instanceiam getting the following error
can not connect (instance name)
instance failure(System.data)
iam using sqlserver dev edition
pls give the solution to fix this issue
Your...
May 26, 2009 at 11:40 pm
shahm10 (5/26/2009)
have you created proper tcp endpoints ?
There's a small problem infact. I created it using SSMS wizard. So for Principal it's coming as "TCP://principalservername.domainname:5022"
but for Mirror "domainnam is not...
May 26, 2009 at 11:33 pm
for always restoration, check the property back of extension like .bak
I dont get you.. Can you pls clarify.
In SQL Server 2005, It's not essential that backup should have ".BAK" extention....
May 26, 2009 at 6:53 am
I ran SP2 and am geting the version as below
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on...
May 26, 2009 at 4:33 am
Viewing 15 posts - 586 through 600 (of 707 total)