Viewing 15 posts - 646 through 660 (of 860 total)
klnsuddu (2/23/2009)
I just want to know that the Differential and log backups for Master database is allowed or NOT?
You cant take a differential/transactional backup of a master database. This is...
February 23, 2009 at 11:36 pm
The only best way to verify a good backup is to restore it to a different server but there are alternatives as well like said abive you can look at...
February 23, 2009 at 2:17 pm
swmsan (2/23/2009)
I installed SQL 2005 without UNINSTALLING SQL 2000.
Wel, I was just practising Backup, Restore etc.
I just tried to chage the recovery mode of database and...
February 23, 2009 at 12:55 am
Check out this kb article, could be useful to you and you can provide us more information:
February 22, 2009 at 11:26 pm
swmsan (2/22/2009)
Dear All,I installed SQL Server 2005 in my home PC. SQL server 2000 was allready existing.
I installed SQL 2005 without installing SQL 2000. Will it make any difference..?
No, it...
February 22, 2009 at 11:16 pm
Hi,
Make sure that the service account(Network service) has write permissions to the network drive.
Check out this article which would be useful:
February 20, 2009 at 11:00 pm
manisha (2/20/2009)
I am not able to take backup on remote disk as its giving me error as" Operating system error 5(Access is denied.)."
Please give me solution
Check your permissions. Make sure...
February 20, 2009 at 10:41 pm
Eswin (2/19/2009)
Can anyone please tell me the command to close a session after that particular process has finished executing.
I am not talking about Kill process, i want...
February 20, 2009 at 10:29 pm
shri_sastry (2/19/2009)
I ran the following command on my server(production)
dbcc sqlperf(logspace)
For one of the databases, here is what I got
DatabaseName ...
February 20, 2009 at 9:26 pm
solution_developer (2/20/2009)
pls help am running out of space and need to either reschedule it or disable the...
February 20, 2009 at 9:16 pm
xgcmcbain (2/20/2009)
as for reubilding indexes, sql server does not do this automatically at some point?
Nope it does not you have to manually do it or create a job using ALTER...
February 20, 2009 at 8:20 pm
MANU (2/20/2009)
Gila,Why you said that "no index on leading field" for a primary key having two columns?
TIA,
MJ
Because in SQL server, the first column is enforced by an index
February 20, 2009 at 8:13 pm
Loner (2/20/2009)
I used to work for companies that had more than 2 production databases and had no DBA. All SQL developers were 'DBA'.
ahh ...developers would have been hammered with...
February 20, 2009 at 1:39 pm
David Kranes (2/20/2009)
February 20, 2009 at 1:35 pm
noeld (2/20/2009)
... but if someone accidentally drops the database your code is gone.
If anyone can "accidentally" DROP a database you have much bigger problems!!!!
You can prevent "accidental" DROP DATABASE using:
1....
February 20, 2009 at 1:31 pm
Viewing 15 posts - 646 through 660 (of 860 total)